﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace Model
{
   public class DbHouseNumber
    {
        #region DbHouseNumber
        /// <summary>
        /// 
        /// </summary>
        public DbHouseNumber()
        {
        }
        /// <summary>	 
        /// 
        /// </summary>
        public DbHouseNumber(Int32 houseNumberID)
        {
            this.houseNumberID = houseNumberID;

        }
        /// <summary>	 
        /// 
        /// </summary>		
        public DbHouseNumber(DataRow dr)
        {
            int.TryParse(Convert.ToString(dr["houseNumberID"]), out houseNumberID);
            int.TryParse(Convert.ToString(dr["houseGroupID"]), out houseGroupID);
            int.TryParse(Convert.ToString(dr["houseRegionID"]), out houseRegionID);
            int.TryParse(Convert.ToString(dr["ParentID"]), out parentID);
            this.houseNumberName = Convert.ToString(dr["houseNumberName"]);
            this.houseArea = Convert.ToString(dr["houseArea"]);
            this.ownerName = Convert.ToString(dr["ownerName"]);
            this.certType = Convert.ToString(dr["certType"]);
            this.certNumber = Convert.ToString(dr["certNumber"]);
            this.phone = Convert.ToString(dr["phone"]);
            this.tel = Convert.ToString(dr["tel"]);
            this.email = Convert.ToString(dr["email"]);
            this.HouseNumberType = Convert.ToString(dr["HouseNumberType"]);
        }
        #endregion


        #region  HouseNumberID int identity(1,1) not null,
        private Int32 houseNumberID;
        /// <summary>	 
        /// 
        /// AutoInc
        /// PK
        /// </summary>
        public Int32 HouseNumberID
        {
            get { return houseNumberID; }
            set { houseNumberID = value; }
        }
        #endregion

        #region HouseGroupID int identity(1,1) not null,
        private Int32 houseGroupID;
        public Int32 HouseGroupID
        {
            get { return houseGroupID; }
            set { houseGroupID = value; }
        }
        #endregion

        #region HouseRegionID int,
        private Int32 houseRegionID;
        public Int32 HouseRegionID
        {
            get { return houseRegionID; }
            set { houseRegionID = value; }
        }
        #endregion

        #region ParentID int,
        private Int32 parentID;
        public Int32 ParentID
        {
            get { return parentID; }
            set { parentID = value; }
        }
        #endregion

       

        #region HouseNumberName varchar(200)
        private string houseNumberName;
        public string HouseNumberName
        {
            get { return houseNumberName; }
            set { houseNumberName = value; }
        }
        #endregion

        #region HouseArea varchar(200),
        private string houseArea;
        public string HouseArea
        {
            get { return houseArea; }
            set { houseArea = value; }
        }
        #endregion
        
        #region OwnerName varchar(200),
        private string ownerName;
        public string OwnerName
        {
            get { return ownerName; }
            set { ownerName = value; }
        }
        #endregion

        #region CertType varchar(200),
        private string certType;
        public string CertType
        {
            get { return certType; }
            set { certType = value; }
        }
        #endregion

        #region CertNumber varchar(200),
        private string certNumber;
        public string CertNumber
        {
            get { return certNumber; }
            set { certNumber = value; }
        }
        #endregion

        #region Phone varchar(200),
        private string phone;
        public string Phone
        {
            get { return phone; }
            set { phone = value; }
        }
        #endregion

        #region Tel varchar(200),
        private string tel;
        public string Tel
        {
            get { return tel; }
            set { tel = value; }
        }
        #endregion

        #region Email varchar(200)
        private string email;
        public string Email
        {
            get { return email; }
            set { email = value; }
        }
        #endregion

        #region HouseNumberType varchar(200)
        private string houseNumberType;
        public string HouseNumberType
        {
            get { return houseNumberType; }
            set { houseNumberType = value; }
        }
        #endregion

    }
}
